package com.kbckbc.easyhangul;

public class Query {
	static String createDB = "CREATE TABLE EasyHangul(_id INTEGER PRIMARY KEY AUTOINCREMENT, words TEXT, sentence TEXT, dttm TEXT);";
	static String dropDB = "DROP TABLE IF EXISTS EasyHangul";
	
	static String selectAll = "SELECT _id, words, sentence, dttm from EasyHangul order by _id desc";
	static String deleteRow = "DELETE FROM EasyHangul WHERE _id in (%d);";
	static String insertRow = "INSERT INTO EasyHangul VALUES (null,'%s','%s','%s');";
	static String updateRow = "UPDATE EasyHangul SET words = '%s', sentence = '%s' , dttm = '%s' where _id = %d";
}

